using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.Common;

/// <summary>
/// Summary description for CatalogAccess
/// </summary>
public class CAdminCatalogAccess
{
	public CAdminCatalogAccess()
	{
	}

    public static DataTable GetDepartments()
    {
        DbCommand command = GenericDataAccess.CreateCommand();
        command.CommandText = "GetCatalog";
        return GenericDataAccess.ExecuteSelectCommand(command);
    }

    public static DataTable GetFoods(string id)
    {
        DbCommand command = GenericDataAccess.CreateCommand();
        command.CommandText = "GetFoods ";
        DbParameter param = command.CreateParameter();
        param.ParameterName = "@Id";
        param.Value = id;
        param.DbType = DbType.Int32;
        command.Parameters.Add(param);
        return GenericDataAccess.ExecuteSelectCommand(command);
    }
    public static DataTable GetAllFoods()
    {
        DbCommand command = GenericDataAccess.CreateCommand();
        command.CommandText = "GetAll_Foods";
        return GenericDataAccess.ExecuteSelectCommand(command);
    }
    public static DataTable GetAllKindOfFood()
    {
        DbCommand command = GenericDataAccess.CreateCommand();
        command.CommandText = "GetAllKindOfFood";
        return GenericDataAccess.ExecuteSelectCommand(command);
    }

    public static void InsertKindOfFood(string name, string image)
    {

    }
}
